-- CREATE TABLE
USE [comunion]
GO

/****** Object:  Table [dbo].[item_supplier]    Script Date: 05/13/2010 15:15:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[item_custcode](
	[cCompanyID] [varchar](10) NOT NULL,
	[cDivision] [varchar](10) NULL,
	[nIdentity] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[cItemNo] [dbo].[ItemNumber] NOT NULL,
	[cCode] [varchar](50) NULL,
	[cName] [varchar](50) NULL,
	[cStockNo] [varchar] (50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


--add field to wrr_t
ALTER TABLE wrr_t ADD cBarcodeID VARCHAR(25) NULL
--add field to dr_t
ALTER TABLE dr_t ADD cCustCode VARCHAR(25) NULL
--add field to item_code
ALTER TABLE item_custcode ADD cBarcodeID VARCHAR(25) NULL
--add field to so
ALTER TABLE so_t ADD cCustCode VARCHAR(25) NULL
--add field to sales/sales_t
ALTER TABLE sales ADD cVatType VARCHAR (15) NULL
ALTER TABLE sales_t ADD cBarcodeID VARCHAR(25) NULL
